﻿using System;
using System.Data;
using System.Data.Common;
using System.Data.SQLite;
using System.Data.OleDb;
using System.Data.Odbc;
using System.Data.SqlClient;
using System.IO;


namespace RebidesSharp
{
    class MainClass
    {
        static void Main(string[] args)
        {

            
            SQLiteCommand sqlite_cmd;
            //SQLiteDataReader sqlite_datareader;
            SQLiteConnection con = new SQLiteConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\ESTIG\\LP\\TP2\\Trabalho\\estiglp1112-5955-csharp\\src\\RebidesSharp\\RebidesSharp\\bin\\Debug\\RebidesSharp.db");
            con.Open(); 

            SQLiteCommand cmd = new SQLiteCommand(); 
            cmd.Connection=con; 
            cmd.CommandType=CommandType.Text;
            sqlite_cmd = con.CreateCommand();
            //sqlite_cmd.CommandText = "CREATE TABLE rebides (cod_docente integer, nome char(50), ult_grau char(20), curso char(30), categoria char(30), regime_tempo varchar(30), ano_lectivo integer, tipo_estabelicimento char(40), nome_estabelicimento char(40));";

            sqlite_cmd.CommandText = "INSERT INTO rebides (cod_docente, nome, ult_grau, curso, categoria, regime_tempo, ano_lectivo, tipo_estabelicimento, nome_estabelicimento) VALUES ( {0}, {1}, {2}, {3}, {4}, {5}, {6}, {7}, {8});";
            
            
            sqlite_cmd.ExecuteNonQuery();
        }
    }
}